/*
Navicat SQL Server Data Transfer

Source Server         : by
Source Server Version : 120000
Source Host           : 192.168.1.122:1433
Source Database       : imuStand
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 120000
File Encoding         : 65001

Date: 2023-12-04 15:17:51
*/


-- ----------------------------
-- Table structure for MemberRank
-- ----------------------------
DROP TABLE [dbo].[MemberRank]
GO
CREATE TABLE [dbo].[MemberRank] (
[id] varchar(500) NOT NULL ,
[createDate] datetime NULL ,
[modifyDate] datetime NULL ,
[isDefault] int NULL ,
[name] varchar(255) NULL ,
[point] int NULL ,
[preferentialScale] decimal(15,5) NULL ,
[ouid_id] varchar(100) NULL ,
[organname] varchar(100) NULL ,
[parent_id] varchar(32) NULL ,
[uploadSpacepaceSize] varchar(50) NULL 
)


GO

-- ----------------------------
-- Records of MemberRank
-- ----------------------------
INSERT INTO [dbo].[MemberRank] ([id], [createDate], [modifyDate], [isDefault], [name], [point], [preferentialScale], [ouid_id], [organname], [parent_id], [uploadSpacepaceSize]) VALUES (N'40288101518fde180151cd8b4473001a', N'2015-12-23 14:33:55.060', N'2015-12-23 14:33:55.060', N'0', N'45445treet二二', null, N'4343.00000', N'402881b4379d0c2e01379d0c9e810002', N'', null, N'4343')
GO
GO
INSERT INTO [dbo].[MemberRank] ([id], [createDate], [modifyDate], [isDefault], [name], [point], [preferentialScale], [ouid_id], [organname], [parent_id], [uploadSpacepaceSize]) VALUES (N'4028810154047ff0015407d2e53a0003', N'2016-04-12 08:15:42.393', N'2016-09-30 11:48:48.903', N'0', N'普通二级网员', null, N'100.00000', N'8a81a02240377cd7014037bee1270003', null, null, N'10')
GO
GO
INSERT INTO [dbo].[MemberRank] ([id], [createDate], [modifyDate], [isDefault], [name], [point], [preferentialScale], [ouid_id], [organname], [parent_id], [uploadSpacepaceSize]) VALUES (N'4028810154047ff0015407d331c40004', N'2016-04-12 08:16:01.987', N'2016-04-12 08:16:01.987', N'0', N'二级站管理员等级', null, N'100.00000', N'8a81a02240377cd7014037bee1260003', N'', null, N'100')
GO
GO
INSERT INTO [dbo].[MemberRank] ([id], [createDate], [modifyDate], [isDefault], [name], [point], [preferentialScale], [ouid_id], [organname], [parent_id], [uploadSpacepaceSize]) VALUES (N'402881b438e018cd0138e02776250002', N'2012-08-01 11:07:58.900', N'2015-12-23 14:34:39.440', N'0', N'本地管理员', null, N'4343.00000', N'402881b4379d0c2e01379d0c9e810002', null, null, N'3443')
GO
GO
INSERT INTO [dbo].[MemberRank] ([id], [createDate], [modifyDate], [isDefault], [name], [point], [preferentialScale], [ouid_id], [organname], [parent_id], [uploadSpacepaceSize]) VALUES (N'402881b438eb21d30138ebbaddeb0008', N'2012-08-03 17:04:48.000', N'2020-04-27 14:49:33.797', N'0', N'本地N500', null, N'1.00000', N'402881b4379d0c2e01379d0c9e810002', null, null, N'434343')
GO
GO
INSERT INTO [dbo].[MemberRank] ([id], [createDate], [modifyDate], [isDefault], [name], [point], [preferentialScale], [ouid_id], [organname], [parent_id], [uploadSpacepaceSize]) VALUES (N'402881fb5a112ff7015ab1b4db5a09b6', N'2017-03-09 14:15:04.000', N'2020-04-27 14:51:14.523', N'1', N'二级网员', null, N'.00000', N'402881b4379d0c2e01379d0c9e810002', null, null, N'50')
GO
GO
INSERT INTO [dbo].[MemberRank] ([id], [createDate], [modifyDate], [isDefault], [name], [point], [preferentialScale], [ouid_id], [organname], [parent_id], [uploadSpacepaceSize]) VALUES (N'402881fb5acc097e015b2250d5146181', N'2017-03-31 11:02:54.000', N'2020-04-27 14:05:02.920', N'0', N'本院内部用户', null, N'100.00000', N'402881b4379d0c2e01379d0c9e810002', null, null, N'50')
GO
GO
INSERT INTO [dbo].[MemberRank] ([id], [createDate], [modifyDate], [isDefault], [name], [point], [preferentialScale], [ouid_id], [organname], [parent_id], [uploadSpacepaceSize]) VALUES (N'402881fb5ba31d7f015ba3a6e8850a28', N'2017-04-25 13:47:56.420', N'2017-04-25 13:47:56.420', N'0', N'包头1', null, N'1.00000', N'402881fb5ba31d7f015ba3a4e38e0a27', N'', null, N'0')
GO
GO
INSERT INTO [dbo].[MemberRank] ([id], [createDate], [modifyDate], [isDefault], [name], [point], [preferentialScale], [ouid_id], [organname], [parent_id], [uploadSpacepaceSize]) VALUES (N'402881fb5d3a00ad015d59c44d750003', N'2017-07-19 15:33:43.413', N'2017-07-19 15:38:33.573', N'0', N'管委会平台', null, N'100.00000', N'8a81a02240377cd7014037bee1270003', null, null, N'30')
GO
GO
INSERT INTO [dbo].[MemberRank] ([id], [createDate], [modifyDate], [isDefault], [name], [point], [preferentialScale], [ouid_id], [organname], [parent_id], [uploadSpacepaceSize]) VALUES (N'402881fb5dc9a85f015e30e342250002', N'2017-08-30 10:05:53.573', N'2017-09-11 17:06:56.230', N'0', N'网员4折', null, N'.00000', N'402881b4379d0c2e01379d0c9e810002', null, null, N'0')
GO
GO
INSERT INTO [dbo].[MemberRank] ([id], [createDate], [modifyDate], [isDefault], [name], [point], [preferentialScale], [ouid_id], [organname], [parent_id], [uploadSpacepaceSize]) VALUES (N'402881fb6706db250167a15cee680009', N'2018-12-12 15:41:21.383', N'2018-12-12 15:41:21.383', N'0', N'网员8折', null, N'.00000', N'402881b4379d0c2e01379d0c9e810002', N'', null, N'0')
GO
GO
INSERT INTO [dbo].[MemberRank] ([id], [createDate], [modifyDate], [isDefault], [name], [point], [preferentialScale], [ouid_id], [organname], [parent_id], [uploadSpacepaceSize]) VALUES (N'8a81a0fb363997e001363999d5300002', N'2012-03-22 16:50:44.657', N'2016-10-08 11:01:29.613', N'0', N'普通网员', null, N'1.00000', N'402881b4379d0c2e01379d0c9e810002', null, null, N'20')
GO
GO
INSERT INTO [dbo].[MemberRank] ([id], [createDate], [modifyDate], [isDefault], [name], [point], [preferentialScale], [ouid_id], [organname], [parent_id], [uploadSpacepaceSize]) VALUES (N'8a81b24631cbebdd0131cc03ec840002', N'2012-08-03 17:06:58.000', N'2013-04-10 16:22:05.953', N'0', N'测试管理员', null, N'500.00000', null, null, null, N'20')
GO
GO

-- ----------------------------
-- Indexes structure for table MemberRank
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table MemberRank
-- ----------------------------
ALTER TABLE [dbo].[MemberRank] ADD PRIMARY KEY ([id])
GO
